package com.isoft.filelistener.dao;

import com.isoft.filelistener.entity.DfmeBllsDflt;
import com.isoft.filelistener.entity.DfmeBllsdfltson;
import com.isoft.filelistener.entity.MetaData;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
@Mapper
public interface DfmeBllsDao {

    @Insert("insert into TEAM_03.DFME_BLLS(SENDER,RECEIVER,SEQUENCE,SEND_TIME,TYPE,STYP," +
            "FLIGHT_FLID,FLIGHT_FFID,FLIGHT_FIDE,FLIGHT_FATT,BLLS_BTNO,BLLS_ID,BLLS_CODE,BLLS_BTAT,BLLS_ESTR,BLLS_EEND,BLLS_BTSC1,BLLS_BTSC2) values(" +
            "#{metaData.sender},#{metaData.receiver},#{metaData.sequence},#{metaData.sendTime},#{metaData.type},#{metaData.styp}," +
            "#{dflt.flightFlid},#{dflt.flightFfid},#{dflt.flightFide},#{dflt.flightFatt},#{dson.bllsBtno},#{dson.bllsId}," +
            "#{dson.bllsCode},#{dson.bllsBtat},#{dson.bllsEstr},#{dson.bllsEend},#{dson.BTSC1},#{dson.BTSC2})")
    int InsertDfmeBlls(@Param("metaData") MetaData metaData, @Param("dflt") DfmeBllsDflt dflt, @Param("dson") DfmeBllsdfltson dfmeBllsdfltson);
}
